UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pt/bWZcP8QpKV4LBVn8vqJyebExavp69fgdQ9BbMZIE='
WHERE
key_id = 'f164a88c4bb441970fdeb28ed3896591177ac21027541d05912f1120fc85a31e'
AND (
token = 'pt/bWZcP8QpKV4LBVn8vqJyebExavp69fgdQ9BbMZIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)