UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'scrA3Yp/T0nw/vhcKMzbXjewn67ltMu1cVR/O5cPuw8='
WHERE
key_id = '23ae3ac751b9b7741af7aaf15f25b372d928a27af08e351325b3603bf0ba1199'
AND (
token = 'scrA3Yp/T0nw/vhcKMzbXjewn67ltMu1cVR/O5cPuw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)