UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QP1oNibkB8ddfJYCKInVrUEwVjH0etv1SJaC8+p9fHs='
WHERE
key_id = '1ae6b26ffa44c6bf5eb8118d759aa212e307be599c26e204a0a14a5d8d7fa255'
AND (
token = 'QP1oNibkB8ddfJYCKInVrUEwVjH0etv1SJaC8+p9fHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)