UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BLnM9X/HoheCiNPhS5Nfe8IVbfpKLv+pGJRzpKwZgig='
WHERE
key_id = '1dcaa9388c6b458b3f88b6235182706fd3f3c37408317456d4e8fc6829979910'
AND (
token = 'BLnM9X/HoheCiNPhS5Nfe8IVbfpKLv+pGJRzpKwZgig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)