UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZkQjx/GWx0s78U6O3xvp6CUn6b9nwobW5NzIkZuKoXc='
WHERE
key_id = '9dec28d1866564f4aa56d6ab30dc34eaf2bf1666ad9162bb352763551372e90e'
AND (
token = 'ZkQjx/GWx0s78U6O3xvp6CUn6b9nwobW5NzIkZuKoXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)