UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lJrB/SfywdGZ66W2uj3WZyPPoM2BQ73LX2p0tkiWWuw='
WHERE
key_id = 'ae518a4bc566ccfba081326812bd647fa941d623d5425df9e7d5954e997d5caf'
AND (
token = 'lJrB/SfywdGZ66W2uj3WZyPPoM2BQ73LX2p0tkiWWuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)