UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r764pjBhxGMiCeMm6RWmwY5Sc+9qkLpB1heJeWx2Fzs='
WHERE
key_id = 'bf2d8c57833392dec2f981cbb87b611521233d0da8fbc34fd3b43e73928e40ce'
AND (
token = 'r764pjBhxGMiCeMm6RWmwY5Sc+9qkLpB1heJeWx2Fzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)