UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kGkPC6XNwABE9QLxPAv8IpRstiqhYncHnKIzDP/LUzU='
WHERE
key_id = 'ef3ec3253d681a9b99566dcbdf7dd25cea1d53212cd2a7728018462fb9fed7af'
AND (
token = 'kGkPC6XNwABE9QLxPAv8IpRstiqhYncHnKIzDP/LUzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)