UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QnkQZtXQL9ynACsmhRsm53BzChu8yg2ltAM7vPmHH50='
WHERE
key_id = '1ed8c35937c0589896d04f5b995720c66f8570b119afcd31d518ac14bfd6c08a'
AND (
token = 'QnkQZtXQL9ynACsmhRsm53BzChu8yg2ltAM7vPmHH50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)