UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u8CmnmiOSuLt44BpotW9/N29wn2/+/aGue+yHbtRUPQ='
WHERE
key_id = '7b80f5dd2eff1cf42afd0e14f1f3f52b5acc69e1ceabeb9cb7e8467e0f19b509'
AND (
token = 'u8CmnmiOSuLt44BpotW9/N29wn2/+/aGue+yHbtRUPQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)