UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nhdKUu78fSy5D9wCn7Pnni4fAOPaBI8842ynAHu6a2Y='
WHERE
key_id = '304a910ecb9268fa8a996320792940bf195b5b81bb068bbb9f833ce434e51727'
AND (
token = 'nhdKUu78fSy5D9wCn7Pnni4fAOPaBI8842ynAHu6a2Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)