UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NhsNCnxqjt4CDG8QBPKqI9GnXy4b7N9b48bQc4jO2eQ='
WHERE
key_id = 'd4d8dc8f38f676ef359886c1e233833743766cc26fee76f75711636282e9f3de'
AND (
token = 'NhsNCnxqjt4CDG8QBPKqI9GnXy4b7N9b48bQc4jO2eQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)