UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3hPA9e3I9d3vc/2B6TscmxuYvaPO7XN65RXsZlVVvmw='
WHERE
key_id = 'cfa9c3cfe69af739967ce4c81ce885ecb0f00c4352746e18ed7f2c1d249000f4'
AND (
token = '3hPA9e3I9d3vc/2B6TscmxuYvaPO7XN65RXsZlVVvmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)