UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3HN0xw7xtJH4CEsGkxnJvfITWAFqzu5oo0UtuXpfZYs='
WHERE
key_id = '8bcceacbd08368bd61c5dce0fd520b0a943d89740f9c027406d8cd5461b89aa5'
AND (
token = '3HN0xw7xtJH4CEsGkxnJvfITWAFqzu5oo0UtuXpfZYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)