UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JnECb7p55J8q3Kng7sfrf4Q2LpTNFv2NOa93flbkIwk='
WHERE
key_id = 'f6e5c0e713005112f5633f9a8575378c19e824ec7283bfd23bf26b1aed8bd3f7'
AND (
token = 'JnECb7p55J8q3Kng7sfrf4Q2LpTNFv2NOa93flbkIwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)