UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DvKzoj6RU5717r1zjTbFo7F7/apT9SqFWOi9zlFvhTc='
WHERE
key_id = 'eff2e72e67405e40ea09c7a9ca1506e1e46d11b939d60259cbcfe69fd2ad8712'
AND (
token = 'DvKzoj6RU5717r1zjTbFo7F7/apT9SqFWOi9zlFvhTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)