UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '04A/GmzvKy3McNoFP1U6N77oCINENxXVzAwPpsJyI7A='
WHERE
key_id = '3f9bc0dda6ca0ef1afd7f635c9f0799ad9d9eb45e655b93b34509211234161fe'
AND (
token = '04A/GmzvKy3McNoFP1U6N77oCINENxXVzAwPpsJyI7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)