UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jD4ZFh3I5b2V64y4Wiz9Aw8GGIpB/hZuF43E9HZUTUA='
WHERE
key_id = '31c2fc6a9a13f9c4801f48ab9bdd377b89c5fe25476c243ccf3852b233583e08'
AND (
token = 'jD4ZFh3I5b2V64y4Wiz9Aw8GGIpB/hZuF43E9HZUTUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)