UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tQUyNO38S0VP0WbtgpBsJLclZZmSQRpA6wzmC6BLPc0='
WHERE
key_id = '178701da3b38ebf16620120e0c4f8d9d3f6a67d352b2c58f7b04e29471eb34a8'
AND (
token = 'tQUyNO38S0VP0WbtgpBsJLclZZmSQRpA6wzmC6BLPc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)