UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1G1M23awb56oRx7NIlHtalIgZL7sSXsOkx50inLmHSw='
WHERE
key_id = '7d7d58f92c02093ae64c06d15e3fee3d37e5de858ee109661420ccc0ebd19a68'
AND (
token = '1G1M23awb56oRx7NIlHtalIgZL7sSXsOkx50inLmHSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)