UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XH72qYnNFDf58ldD7FiMemZGHbCirkgs2l/C4wbFizk='
WHERE
key_id = '6546aeaa595a24ffa7167bf62ca215a053f04347c9f9370e9eb66e25648a7c29'
AND (
token = 'XH72qYnNFDf58ldD7FiMemZGHbCirkgs2l/C4wbFizk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)