UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7q2dOjLEttcDnXt50j9RoZriE9WQoKCyEG/ENSFoAYY='
WHERE
key_id = 'a5305f3f7ea42cfb7686928c663f17cf77631c99900072719ff533d00820f7a1'
AND (
token = '7q2dOjLEttcDnXt50j9RoZriE9WQoKCyEG/ENSFoAYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)