UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/1cgUgNBPo65GgiJ9q6e71MRHj3u5O0fp6vMmtlfDo0='
WHERE
key_id = 'e4b0c997bc8d5900c8033ee91530e8f4f3306aa90a81754246896317650c6dc5'
AND (
token = '/1cgUgNBPo65GgiJ9q6e71MRHj3u5O0fp6vMmtlfDo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)