UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nvW6cPT4KJSpLiJHF8evi0px0xLjbFYb648MQRp1bo4='
WHERE
key_id = '089f39c6a001ec0814c3fd61e17e23014e872468ca99f463159e3cd9ac06f25b'
AND (
token = 'nvW6cPT4KJSpLiJHF8evi0px0xLjbFYb648MQRp1bo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)