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