UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wPDV5VBi40MHOTtlXOiJTiXk1i3X+4jnI4UU4vCs24E='
WHERE
key_id = 'a293ae63557bed9580513e538fc385e991a336eb00f4922b4cdb794fcaf2db2f'
AND (
token = 'wPDV5VBi40MHOTtlXOiJTiXk1i3X+4jnI4UU4vCs24E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)