UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9cKs9OpHOJbCxw72gnOK7C/i+W28zh/VGN4r2zackB8='
WHERE
key_id = '223ab18056410753936c2de016d0c326a8b1fee51095ea84a46bc1ce896a0ac1'
AND (
token = '9cKs9OpHOJbCxw72gnOK7C/i+W28zh/VGN4r2zackB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)