UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XAuu2+CQsW3/W9uauM711zZAi0SEwXEdSvM67F3nIgw='
WHERE
key_id = '0ac8907e15a7e4ce9e4b798bc1b7ad65f9401afe7708c05e02745a15f6c87ea3'
AND (
token = 'XAuu2+CQsW3/W9uauM711zZAi0SEwXEdSvM67F3nIgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)