UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4EdHz2I/juz7oRyNdfi8PXNOhqJAJ9Uq5WNJ/096uww='
WHERE
key_id = '421205a7580d532bbe13b5112db99c21e602f4ab5cfc81353a980726d540c16f'
AND (
token = '4EdHz2I/juz7oRyNdfi8PXNOhqJAJ9Uq5WNJ/096uww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)