UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HCsepIOtCRd1gMQSmOqpRTcNX50aT/2abQsJZ8A5DgA='
WHERE
key_id = 'bdea9b1b19129d2a282aa8ec54334b583ed91c09739a56bd64d25a69915727f8'
AND (
token = 'HCsepIOtCRd1gMQSmOqpRTcNX50aT/2abQsJZ8A5DgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)