UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3zCX/cW2ImMwj283uYuCFNDqFTGN+ZTgVmrfhwoah2s='
WHERE
key_id = '0b7552e1e50af76e96728c260c531dc97b187e41a039e0ad9810f1812456efff'
AND (
token = '3zCX/cW2ImMwj283uYuCFNDqFTGN+ZTgVmrfhwoah2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)