UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5XPgdufraQGcUKNrNFvPOTsuZEXvROU6N1Yz7Wchwnk='
WHERE
key_id = '3d7114492ba109e55026c7c6f1c34b0a08b6d04208d24d4da7b304d3366584ab'
AND (
token = '5XPgdufraQGcUKNrNFvPOTsuZEXvROU6N1Yz7Wchwnk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)