UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TKY6wLNx91y1ZCwA5fS/WkSTg1KWBywRkX1BRJ1q7h8='
WHERE
key_id = '4e0c306f02868d4291a4145f095fcf81d3364075c2351f9c2d14800517acc2a5'
AND (
token = 'TKY6wLNx91y1ZCwA5fS/WkSTg1KWBywRkX1BRJ1q7h8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)