UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zAJzD2pokFmBOER+mDA7A6H3qHbFj2veoJAnfsEjOpw='
WHERE
key_id = 'c64165b1773fe879c8e307d87273068f550acf0a06f558ccce88cb7f19a16410'
AND (
token = 'zAJzD2pokFmBOER+mDA7A6H3qHbFj2veoJAnfsEjOpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)