UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NJyc1nK9Ke04l2p9ZbLLfUyHkV6z4meSPAc9l7iDpkc='
WHERE
key_id = 'dfd8ec82deb1ea6da3b9e9cd889cb04cdb714da611a3da675b39ef3e75f4f4cb'
AND (
token = 'NJyc1nK9Ke04l2p9ZbLLfUyHkV6z4meSPAc9l7iDpkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)