UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8oCDCYSEEvNulWCs1qnekq17zG9NkCAL23sQSa+vq94='
WHERE
key_id = '3aca0f76a1282bbe2a471d6d74b860b75430c492989e66d10ab51d32ac9e29db'
AND (
token = '8oCDCYSEEvNulWCs1qnekq17zG9NkCAL23sQSa+vq94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)