UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'idcmrTZxK2YiRGY7jOjTIJpxpcNB7iayIHZ8JIdPgBw='
WHERE
key_id = '25541398d7d7ecb8d470da25f28d285b02d3b2d35d54a143d7fa215bf8711fc8'
AND (
token = 'idcmrTZxK2YiRGY7jOjTIJpxpcNB7iayIHZ8JIdPgBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)