UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DLlV5Ie8yAViCroU4yyCRSD8DWpvU7GF/y4qm3UbV+I='
WHERE
key_id = 'caad3af3c160b55ea0ddb4be888e6460acbf0836f8559f9890311364ff312fdc'
AND (
token = 'DLlV5Ie8yAViCroU4yyCRSD8DWpvU7GF/y4qm3UbV+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)