UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZjo90D/+yBgRlcR1DG3O21lFKy7aFWEY8pJpli7qNk='
WHERE
key_id = 'cd7e8eb232f75661b08f8cea3806dd150238c381eda007620cdc5a7462a81564'
AND (
token = 'zZjo90D/+yBgRlcR1DG3O21lFKy7aFWEY8pJpli7qNk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)