UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z64drOu4J7j5FMIwLbk7lE9+yUBqn612JP3/P42WRZM='
WHERE
key_id = 'f014f58756b7d44c62d65c3a670ce4f526480c809e786f0060bff8c59a077cb6'
AND (
token = 'z64drOu4J7j5FMIwLbk7lE9+yUBqn612JP3/P42WRZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)